package com.groupsix.mapper;

import com.groupsix.entity.Stgrade;
import com.groupsix.entity.StgradeExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

/**
 * 学生卫生
 */
public interface StgradeMapper {


    /**
     * 进行分页查询
     */
    //获取总条数
    public Integer totalCount(@Param("sStudentid") Integer sStudentid, @Param("sName") String sName,@Param("sDormitoryid") Integer sDormitoryid);
    //获取用户列表
    public List<Stgrade> getStgradeList(@Param("sStudentid") Integer sStudentid, @Param("sName") String sName, @Param("sDormitoryid") Integer sDormitoryid, @Param("currentPage") Integer currentPage, @Param("pageSize") Integer pageSize);

    public int addStgrade(Stgrade stgrade);    //添加宿舍卫生信息
    public int deleteStgrade(Integer gId);   //删除宿舍卫生信息
    public int updateStgrade(Stgrade stgrade); //修改学生卫生信息
    public Stgrade findStgradeById(Integer gId); //通过id修改学生卫生信息
    //查询全部
    public List<Stgrade> getAll();




    int countByExample(StgradeExample example);

    int deleteByExample(StgradeExample example);

    int deleteByPrimaryKey(Integer gId);

    int insert(Stgrade record);

    int insertSelective(Stgrade record);

    List<Stgrade> selectByExample(StgradeExample example);

    Stgrade selectByPrimaryKey(Integer gId);

    int updateByExampleSelective(@Param("record") Stgrade record, @Param("example") StgradeExample example);

    int updateByExample(@Param("record") Stgrade record, @Param("example") StgradeExample example);

    int updateByPrimaryKeySelective(Stgrade record);

    int updateByPrimaryKey(Stgrade record);
}